Dataset statistics
| Number of variables | 19 |
|---|---|
| Number of observations | 289926 |
| Missing cells | 1531611 |
| Missing cells (%) | 27.8% |
| Duplicate rows | 257 |
| Duplicate rows (%) | 0.1% |
| Total size in memory | 42.0 MiB |
| Average record size in memory | 152.0 B |
Variable types
| Numeric | 10 |
|---|---|
| Categorical | 5 |
| Text | 1 |
| DateTime | 3 |
| Dataset has 257 (0.1%) duplicate rows | Duplicates |
ad_description_len is highly overall correlated with ad_type | High correlation |
ad_type is highly overall correlated with ad_description_len and 1 other fields | High correlation |
call_status is highly overall correlated with duration | High correlation |
clicks is highly overall correlated with cost and 2 other fields | High correlation |
conversions_calls is highly overall correlated with duration | High correlation |
cost is highly overall correlated with clicks and 1 other fields | High correlation |
display_location is highly overall correlated with clicks | High correlation |
duration is highly overall correlated with call_status and 1 other fields | High correlation |
headline1_len is highly overall correlated with ad_type | High correlation |
impressions is highly overall correlated with clicks and 1 other fields | High correlation |
currency is highly imbalanced (70.7%) | Imbalance |
call_type is highly imbalanced (89.0%) | Imbalance |
call_type has 253026 (87.3%) missing values | Missing |
call_status has 253026 (87.3%) missing values | Missing |
start_time has 253026 (87.3%) missing values | Missing |
duration has 253026 (87.3%) missing values | Missing |
end_time has 253026 (87.3%) missing values | Missing |
display_location has 253026 (87.3%) missing values | Missing |
conversions_calls has 9855 (3.4%) missing values | Missing |
clicks is highly skewed (γ1 = 27.63556565) | Skewed |
cost is highly skewed (γ1 = 25.78260393) | Skewed |
conversions is highly skewed (γ1 = 24.77355007) | Skewed |
clicks has 79042 (27.3%) zeros | Zeros |
cost has 79042 (27.3%) zeros | Zeros |
conversions has 278470 (96.0%) zeros | Zeros |
duration has 9879 (3.4%) zeros | Zeros |
conversions_calls has 258674 (89.2%) zeros | Zeros |
headline1_len has 31252 (10.8%) zeros | Zeros |
headline2_len has 31252 (10.8%) zeros | Zeros |
ad_description_len has 31252 (10.8%) zeros | Zeros |
Reproduction
| Analysis started | 2024-04-06 12:19:19.061690 |
|---|---|
| Analysis finished | 2024-04-06 12:20:26.849479 |
| Duration | 1 minute and 7.79 seconds |
| Software version | ydata-profiling vv4.7.0 |
| Download configuration | config.json |
impressions
Real number (ℝ)
HIGH CORRELATION
| Distinct | 1600 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 400 |
| Missing (%) | 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 72.80962 |
| Minimum | 0 |
|---|---|
| Maximum | 6833 |
| Zeros | 5 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 6 |
| median | 23 |
| Q3 | 69 |
| 95-th percentile | 320 |
| Maximum | 6833 |
| Range | 6833 |
| Interquartile range (IQR) | 63 |
Descriptive statistics
| Standard deviation | 153.59279 |
|---|---|
| Coefficient of variation (CV) | 2.1095123 |
| Kurtosis | 101.96793 |
| Mean | 72.80962 |
| Median Absolute Deviation (MAD) | 20 |
| Skewness | 6.8263544 |
| Sum | 21080278 |
| Variance | 23590.746 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 22642 | 7.8% |
| 2 | 14500 | 5.0% |
| 3 | 11327 | 3.9% |
| 4 | 9673 | 3.3% |
| 5 | 8523 | 2.9% |
| 6 | 7554 | 2.6% |
| 7 | 6847 | 2.4% |
| 8 | 6346 | 2.2% |
| 9 | 5802 | 2.0% |
| 10 | 5346 | 1.8% |
| Other values (1590) | 190966 |
| Value | Count | Frequency (%) |
| 0 | 5 | < 0.1% |
| 1 | 22642 | |
| 2 | 14500 | |
| 3 | 11327 | |
| 4 | 9673 | |
| 5 | 8523 | 2.9% |
| 6 | 7554 | 2.6% |
| 7 | 6847 | 2.4% |
| 8 | 6346 | 2.2% |
| 9 | 5802 | 2.0% |
| Value | Count | Frequency (%) |
| 6833 | 1 | |
| 5607 | 1 | |
| 5407 | 1 | |
| 4991 | 1 | |
| 4938 | 1 | |
| 4704 | 1 | |
| 4608 | 1 | |
| 4488 | 1 | |
| 4403 | 1 | |
| 4169 | 1 |
clicks
Real number (ℝ)
HIGH CORRELATION SKEWED ZEROS
| Distinct | 714 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 400 |
| Missing (%) | 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.0399273 |
| Minimum | 0 |
|---|---|
| Maximum | 4227 |
| Zeros | 79042 |
| Zeros (%) | 27.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 2 |
| Q3 | 6 |
| 95-th percentile | 30 |
| Maximum | 4227 |
| Range | 4227 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 36.241161 |
|---|---|
| Coefficient of variation (CV) | 4.5076478 |
| Kurtosis | 1467.1623 |
| Mean | 8.0399273 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 27.635566 |
| Sum | 2327768 |
| Variance | 1313.4218 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 79042 | |
| 1 | 47826 | |
| 2 | 30843 | 10.6% |
| 3 | 21876 | 7.5% |
| 4 | 16519 | 5.7% |
| 5 | 12557 | 4.3% |
| 6 | 9842 | 3.4% |
| 7 | 8119 | 2.8% |
| 8 | 6655 | 2.3% |
| 9 | 5654 | 2.0% |
| Other values (704) | 50593 |
| Value | Count | Frequency (%) |
| 0 | 79042 | |
| 1 | 47826 | |
| 2 | 30843 | 10.6% |
| 3 | 21876 | 7.5% |
| 4 | 16519 | 5.7% |
| 5 | 12557 | 4.3% |
| 6 | 9842 | 3.4% |
| 7 | 8119 | 2.8% |
| 8 | 6655 | 2.3% |
| 9 | 5654 | 2.0% |
| Value | Count | Frequency (%) |
| 4227 | 1 | |
| 2813 | 1 | |
| 2367 | 1 | |
| 2295 | 1 | |
| 2288 | 1 | |
| 2283 | 1 | |
| 1834 | 1 | |
| 1767 | 1 | |
| 1729 | 1 | |
| 1717 | 1 |
cost
Real number (ℝ)
HIGH CORRELATION SKEWED ZEROS
| Distinct | 82548 |
|---|---|
| Distinct (%) | 28.5% |
| Missing | 400 |
| Missing (%) | 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2208.5251 |
| Minimum | 0 |
|---|---|
| Maximum | 719928 |
| Zeros | 79042 |
| Zeros (%) | 27.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 553 |
| Q3 | 2062.5 |
| 95-th percentile | 8684 |
| Maximum | 719928 |
| Range | 719928 |
| Interquartile range (IQR) | 2062.5 |
Descriptive statistics
| Standard deviation | 7392.6097 |
|---|---|
| Coefficient of variation (CV) | 3.3473063 |
| Kurtosis | 1471.5102 |
| Mean | 2208.5251 |
| Median Absolute Deviation (MAD) | 553 |
| Skewness | 25.782604 |
| Sum | 6.3942542 × 108 |
| Variance | 54650679 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 79042 | 27.3% |
| 4 | 500 | 0.2% |
| 6 | 333 | 0.1% |
| 23 | 324 | 0.1% |
| 5 | 287 | 0.1% |
| 8 | 254 | 0.1% |
| 10 | 222 | 0.1% |
| 52 | 195 | 0.1% |
| 20 | 182 | 0.1% |
| 18 | 159 | 0.1% |
| Other values (82538) | 208028 | |
| (Missing) | 400 | 0.1% |
| Value | Count | Frequency (%) |
| 0 | 79042 | |
| 1 | 5 | < 0.1% |
| 1 | 128 | < 0.1% |
| 1.249190939 | 1 | < 0.1% |
| 1.249706917 | 1 | < 0.1% |
| 1.249951647 | 1 | < 0.1% |
| 1.249961568 | 1 | < 0.1% |
| 2 | 10 | < 0.1% |
| 2 | 130 | < 0.1% |
| 2.498659517 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 719928 | 3 | |
| 543780 | 2 | |
| 345962 | 1 | < 0.1% |
| 345723 | 1 | < 0.1% |
| 337973.75 | 1 | < 0.1% |
| 326958.75 | 1 | < 0.1% |
| 300990.5296 | 1 | < 0.1% |
| 297544 | 1 | < 0.1% |
| 296324.6296 | 1 | < 0.1% |
| 295796 | 1 | < 0.1% |
conversions
Real number (ℝ)
SKEWED ZEROS
| Distinct | 238 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 400 |
| Missing (%) | 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.79013975 |
| Minimum | 0 |
|---|---|
| Maximum | 1297 |
| Zeros | 278470 |
| Zeros (%) | 96.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 1297 |
| Range | 1297 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 10.298258 |
|---|---|
| Coefficient of variation (CV) | 13.033464 |
| Kurtosis | 1296.7188 |
| Mean | 0.79013975 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 24.77355 |
| Sum | 228766 |
| Variance | 106.05411 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 278470 | |
| 1 | 4833 | 1.7% |
| 2 | 1690 | 0.6% |
| 3 | 709 | 0.2% |
| 4 | 422 | 0.1% |
| 5 | 246 | 0.1% |
| 6 | 191 | 0.1% |
| 7 | 160 | 0.1% |
| 8 | 133 | < 0.1% |
| 10 | 81 | < 0.1% |
| Other values (228) | 2591 | 0.9% |
| (Missing) | 400 | 0.1% |
| Value | Count | Frequency (%) |
| 0 | 278470 | |
| 1 | 4833 | 1.7% |
| 2 | 1690 | 0.6% |
| 3 | 709 | 0.2% |
| 4 | 422 | 0.1% |
| 5 | 246 | 0.1% |
| 6 | 191 | 0.1% |
| 7 | 160 | 0.1% |
| 8 | 133 | < 0.1% |
| 9 | 65 | < 0.1% |
| Value | Count | Frequency (%) |
| 1297 | 1 | < 0.1% |
| 426 | 1 | < 0.1% |
| 422 | 6 | |
| 421 | 3 | |
| 385 | 1 | < 0.1% |
| 382 | 5 | |
| 364 | 1 | < 0.1% |
| 362 | 1 | < 0.1% |
| 344 | 4 | |
| 334 | 1 | < 0.1% |
ad_type
Categorical
HIGH CORRELATION
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 400 |
| Missing (%) | 0.1% |
| Memory size | 2.2 MiB |
| EXPANDED_TEXT_AD | |
|---|---|
| RESPONSIVE_SEARCH_AD | |
| EXPANDED_DYNAMIC_SEARCH_AD |
Length
| Max length | 26 |
|---|---|
| Median length | 16 |
| Mean length | 18.874892 |
| Min length | 16 |
Characters and Unicode
| Total characters | 5464772 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | EXPANDED_TEXT_AD |
|---|---|
| 2nd row | EXPANDED_TEXT_AD |
| 3rd row | EXPANDED_TEXT_AD |
| 4th row | EXPANDED_TEXT_AD |
| 5th row | EXPANDED_TEXT_AD |
Common Values
| Value | Count | Frequency (%) |
| EXPANDED_TEXT_AD | 148103 | |
| RESPONSIVE_SEARCH_AD | 96979 | |
| EXPANDED_DYNAMIC_SEARCH_AD | 44444 | 15.3% |
| (Missing) | 400 | 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| expanded_text_ad | 148103 | |
| responsive_search_ad | 96979 | |
| expanded_dynamic_search_ad | 44444 | 15.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 868578 | |
| D | 719064 | |
| A | 667940 | |
| _ | 623496 | |
| X | 340650 | 6.2% |
| S | 335381 | 6.1% |
| N | 333970 | 6.1% |
| T | 296206 | 5.4% |
| P | 289526 | 5.3% |
| R | 238402 | 4.4% |
| Other values (7) | 751559 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 5464772 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| E | 868578 | |
| D | 719064 | |
| A | 667940 | |
| _ | 623496 | |
| X | 340650 | 6.2% |
| S | 335381 | 6.1% |
| N | 333970 | 6.1% |
| T | 296206 | 5.4% |
| P | 289526 | 5.3% |
| R | 238402 | 4.4% |
| Other values (7) | 751559 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 5464772 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| E | 868578 | |
| D | 719064 | |
| A | 667940 | |
| _ | 623496 | |
| X | 340650 | 6.2% |
| S | 335381 | 6.1% |
| N | 333970 | 6.1% |
| T | 296206 | 5.4% |
| P | 289526 | 5.3% |
| R | 238402 | 4.4% |
| Other values (7) | 751559 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 5464772 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| E | 868578 | |
| D | 719064 | |
| A | 667940 | |
| _ | 623496 | |
| X | 340650 | 6.2% |
| S | 335381 | 6.1% |
| N | 333970 | 6.1% |
| T | 296206 | 5.4% |
| P | 289526 | 5.3% |
| R | 238402 | 4.4% |
| Other values (7) | 751559 |
currency
Categorical
IMBALANCE
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 400 |
| Missing (%) | 0.1% |
| Memory size | 2.2 MiB |
| ZAR | |
|---|---|
| USD | 14909 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 868578 |
|---|---|
| Distinct characters | 6 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | ZAR |
|---|---|
| 2nd row | ZAR |
| 3rd row | ZAR |
| 4th row | ZAR |
| 5th row | ZAR |
Common Values
| Value | Count | Frequency (%) |
| ZAR | 274617 | |
| USD | 14909 | 5.1% |
| (Missing) | 400 | 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| zar | 274617 | |
| usd | 14909 | 5.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| Z | 274617 | |
| A | 274617 | |
| R | 274617 | |
| U | 14909 | 1.7% |
| S | 14909 | 1.7% |
| D | 14909 | 1.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 868578 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| Z | 274617 | |
| A | 274617 | |
| R | 274617 | |
| U | 14909 | 1.7% |
| S | 14909 | 1.7% |
| D | 14909 | 1.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 868578 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| Z | 274617 | |
| A | 274617 | |
| R | 274617 | |
| U | 14909 | 1.7% |
| S | 14909 | 1.7% |
| D | 14909 | 1.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 868578 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| Z | 274617 | |
| A | 274617 | |
| R | 274617 | |
| U | 14909 | 1.7% |
| S | 14909 | 1.7% |
| D | 14909 | 1.7% |
ID
Text
| Distinct | 185 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.2 MiB |
Length
| Max length | 27 |
|---|---|
| Median length | 27 |
| Mean length | 27 |
| Min length | 27 |
Characters and Unicode
| Total characters | 7828002 |
|---|---|
| Distinct characters | 19 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | ID_5da86e71bf5dee4cf5047046 |
|---|---|
| 2nd row | ID_5da86e71bf5dee4cf5047046 |
| 3rd row | ID_5da86e71bf5dee4cf5047046 |
| 4th row | ID_5da86e71bf5dee4cf5047046 |
| 5th row | ID_5da86e71bf5dee4cf5047046 |
| Value | Count | Frequency (%) |
| id_5da86e71bf5dee4cf5047046 | 15150 | 5.2% |
| id_5ee74f25f865a8154966b412 | 9539 | 3.3% |
| id_600d8eaaf5c7660c0b1f0773 | 8693 | 3.0% |
| id_5f3cdce8c0440e2c5902dd59 | 8658 | 3.0% |
| id_61321c129a9b4c145436394d | 8629 | 3.0% |
| id_60f12ace56214677d611d526 | 8397 | 2.9% |
| id_604752a9861a02467a27c054 | 7790 | 2.7% |
| id_60e556f789173d61d07e3294 | 7713 | 2.7% |
| id_6103b50cd6d4a602e4370f05 | 7459 | 2.6% |
| id_60e5572b44311c0aa4513107 | 6908 | 2.4% |
| Other values (175) | 200990 |
Most occurring characters
| Value | Count | Frequency (%) |
| 6 | 690365 | 8.8% |
| 5 | 562134 | 7.2% |
| 4 | 546438 | 7.0% |
| 0 | 498968 | 6.4% |
| 1 | 498002 | 6.4% |
| 7 | 486120 | 6.2% |
| 2 | 454026 | 5.8% |
| c | 387724 | 5.0% |
| a | 379980 | 4.9% |
| 8 | 372094 | 4.8% |
| Other values (9) | 2952151 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7828002 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 6 | 690365 | 8.8% |
| 5 | 562134 | 7.2% |
| 4 | 546438 | 7.0% |
| 0 | 498968 | 6.4% |
| 1 | 498002 | 6.4% |
| 7 | 486120 | 6.2% |
| 2 | 454026 | 5.8% |
| c | 387724 | 5.0% |
| a | 379980 | 4.9% |
| 8 | 372094 | 4.8% |
| Other values (9) | 2952151 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7828002 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 6 | 690365 | 8.8% |
| 5 | 562134 | 7.2% |
| 4 | 546438 | 7.0% |
| 0 | 498968 | 6.4% |
| 1 | 498002 | 6.4% |
| 7 | 486120 | 6.2% |
| 2 | 454026 | 5.8% |
| c | 387724 | 5.0% |
| a | 379980 | 4.9% |
| 8 | 372094 | 4.8% |
| Other values (9) | 2952151 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7828002 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 6 | 690365 | 8.8% |
| 5 | 562134 | 7.2% |
| 4 | 546438 | 7.0% |
| 0 | 498968 | 6.4% |
| 1 | 498002 | 6.4% |
| 7 | 486120 | 6.2% |
| 2 | 454026 | 5.8% |
| c | 387724 | 5.0% |
| a | 379980 | 4.9% |
| 8 | 372094 | 4.8% |
| Other values (9) | 2952151 |
date
Date
| Distinct | 1505 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.2 MiB |
| Minimum | 2020-01-01 00:00:00 |
|---|---|
| Maximum | 2024-02-13 00:00:00 |
Histogram with fixed size bins (bins=50)
call_type
Categorical
IMBALANCE MISSING
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 253026 |
| Missing (%) | 87.3% |
| Memory size | 2.2 MiB |
| Mobile click-to-call | |
|---|---|
| Manually dialed | 537 |
Length
| Max length | 20 |
|---|---|
| Median length | 20 |
| Mean length | 19.927236 |
| Min length | 15 |
Characters and Unicode
| Total characters | 735315 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Mobile click-to-call |
|---|---|
| 2nd row | Mobile click-to-call |
| 3rd row | Mobile click-to-call |
| 4th row | Mobile click-to-call |
| 5th row | Mobile click-to-call |
Common Values
| Value | Count | Frequency (%) |
| Mobile click-to-call | 36363 | 12.5% |
| Manually dialed | 537 | 0.2% |
| (Missing) | 253026 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| mobile | 36363 | |
| click-to-call | 36363 | |
| manually | 537 | 0.7% |
| dialed | 537 | 0.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| l | 147063 | |
| c | 109089 | |
| i | 73263 | |
| o | 72726 | |
| - | 72726 | |
| a | 37974 | 5.2% |
| M | 36900 | 5.0% |
| e | 36900 | 5.0% |
| 36900 | 5.0% | |
| b | 36363 | 4.9% |
| Other values (6) | 75411 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 735315 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| l | 147063 | |
| c | 109089 | |
| i | 73263 | |
| o | 72726 | |
| - | 72726 | |
| a | 37974 | 5.2% |
| M | 36900 | 5.0% |
| e | 36900 | 5.0% |
| 36900 | 5.0% | |
| b | 36363 | 4.9% |
| Other values (6) | 75411 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 735315 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| l | 147063 | |
| c | 109089 | |
| i | 73263 | |
| o | 72726 | |
| - | 72726 | |
| a | 37974 | 5.2% |
| M | 36900 | 5.0% |
| e | 36900 | 5.0% |
| 36900 | 5.0% | |
| b | 36363 | 4.9% |
| Other values (6) | 75411 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 735315 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| l | 147063 | |
| c | 109089 | |
| i | 73263 | |
| o | 72726 | |
| - | 72726 | |
| a | 37974 | 5.2% |
| M | 36900 | 5.0% |
| e | 36900 | 5.0% |
| 36900 | 5.0% | |
| b | 36363 | 4.9% |
| Other values (6) | 75411 |
call_status
Categorical
HIGH CORRELATION MISSING
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 253026 |
| Missing (%) | 87.3% |
| Memory size | 2.2 MiB |
| Received | |
|---|---|
| Missed |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 7.4773442 |
| Min length | 6 |
Characters and Unicode
| Total characters | 275914 |
|---|---|
| Distinct characters | 8 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Missed |
|---|---|
| 2nd row | Missed |
| 3rd row | Missed |
| 4th row | Missed |
| 5th row | Missed |
Common Values
| Value | Count | Frequency (%) |
| Received | 27257 | 9.4% |
| Missed | 9643 | 3.3% |
| (Missing) | 253026 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| received | 27257 | |
| missed | 9643 | 26.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 91414 | |
| i | 36900 | |
| d | 36900 | |
| R | 27257 | 9.9% |
| c | 27257 | 9.9% |
| v | 27257 | 9.9% |
| s | 19286 | 7.0% |
| M | 9643 | 3.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 275914 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 91414 | |
| i | 36900 | |
| d | 36900 | |
| R | 27257 | 9.9% |
| c | 27257 | 9.9% |
| v | 27257 | 9.9% |
| s | 19286 | 7.0% |
| M | 9643 | 3.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 275914 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 91414 | |
| i | 36900 | |
| d | 36900 | |
| R | 27257 | 9.9% |
| c | 27257 | 9.9% |
| v | 27257 | 9.9% |
| s | 19286 | 7.0% |
| M | 9643 | 3.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 275914 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 91414 | |
| i | 36900 | |
| d | 36900 | |
| R | 27257 | 9.9% |
| c | 27257 | 9.9% |
| v | 27257 | 9.9% |
| s | 19286 | 7.0% |
| M | 9643 | 3.5% |
start_time
Date
MISSING
| Distinct | 7488 |
|---|---|
| Distinct (%) | 20.3% |
| Missing | 253026 |
| Missing (%) | 87.3% |
| Memory size | 2.2 MiB |
| Minimum | 2020-10-22 20:27:53 |
|---|---|
| Maximum | 2024-02-13 16:55:14 |
Histogram with fixed size bins (bins=50)
duration
Real number (ℝ)
HIGH CORRELATION MISSING ZEROS
| Distinct | 473 |
|---|---|
| Distinct (%) | 1.3% |
| Missing | 253026 |
| Missing (%) | 87.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 67.96897 |
| Minimum | 0 |
|---|---|
| Maximum | 2125 |
| Zeros | 9879 |
| Zeros (%) | 3.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 36 |
| Q3 | 95 |
| 95-th percentile | 245 |
| Maximum | 2125 |
| Range | 2125 |
| Interquartile range (IQR) | 95 |
Descriptive statistics
| Standard deviation | 98.055148 |
|---|---|
| Coefficient of variation (CV) | 1.4426458 |
| Kurtosis | 37.8807 |
| Mean | 67.96897 |
| Median Absolute Deviation (MAD) | 36 |
| Skewness | 4.0438037 |
| Sum | 2508055 |
| Variance | 9614.812 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 9879 | 3.4% |
| 3 | 594 | 0.2% |
| 4 | 508 | 0.2% |
| 2 | 457 | 0.2% |
| 5 | 343 | 0.1% |
| 1 | 304 | 0.1% |
| 28 | 300 | 0.1% |
| 19 | 283 | 0.1% |
| 6 | 266 | 0.1% |
| 32 | 264 | 0.1% |
| Other values (463) | 23702 | 8.2% |
| (Missing) | 253026 |
| Value | Count | Frequency (%) |
| 0 | 9879 | |
| 1 | 304 | 0.1% |
| 2 | 457 | 0.2% |
| 3 | 594 | 0.2% |
| 4 | 508 | 0.2% |
| 5 | 343 | 0.1% |
| 6 | 266 | 0.1% |
| 7 | 232 | 0.1% |
| 8 | 209 | 0.1% |
| 9 | 168 | 0.1% |
| Value | Count | Frequency (%) |
| 2125 | 2 | < 0.1% |
| 1788 | 3 | < 0.1% |
| 1390 | 9 | |
| 1378 | 2 | < 0.1% |
| 1025 | 2 | < 0.1% |
| 964 | 4 | |
| 951 | 3 | < 0.1% |
| 914 | 3 | < 0.1% |
| 905 | 9 | |
| 899 | 2 | < 0.1% |
end_time
Date
MISSING
| Distinct | 7490 |
|---|---|
| Distinct (%) | 20.3% |
| Missing | 253026 |
| Missing (%) | 87.3% |
| Memory size | 2.2 MiB |
| Minimum | 2020-10-22 20:27:53 |
|---|---|
| Maximum | 2024-02-13 16:55:14 |
Histogram with fixed size bins (bins=50)
display_location
Categorical
HIGH CORRELATION MISSING
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 253026 |
| Missing (%) | 87.3% |
| Memory size | 2.2 MiB |
| AD | |
|---|---|
| Ad | |
| LANDING_PAGE | 1123 |
| Website | 996 |
Length
| Max length | 12 |
|---|---|
| Median length | 2 |
| Mean length | 2.4392954 |
| Min length | 2 |
Characters and Unicode
| Total characters | 90010 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Ad |
|---|---|
| 2nd row | Ad |
| 3rd row | Ad |
| 4th row | Ad |
| 5th row | Ad |
Common Values
| Value | Count | Frequency (%) |
| AD | 23338 | 8.0% |
| Ad | 11443 | 3.9% |
| LANDING_PAGE | 1123 | 0.4% |
| Website | 996 | 0.3% |
| (Missing) | 253026 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| ad | 34781 | |
| landing_page | 1123 | 3.0% |
| website | 996 | 2.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 37027 | |
| D | 24461 | |
| d | 11443 | 12.7% |
| N | 2246 | 2.5% |
| G | 2246 | 2.5% |
| e | 1992 | 2.2% |
| L | 1123 | 1.2% |
| I | 1123 | 1.2% |
| _ | 1123 | 1.2% |
| P | 1123 | 1.2% |
| Other values (6) | 6103 | 6.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 90010 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 37027 | |
| D | 24461 | |
| d | 11443 | 12.7% |
| N | 2246 | 2.5% |
| G | 2246 | 2.5% |
| e | 1992 | 2.2% |
| L | 1123 | 1.2% |
| I | 1123 | 1.2% |
| _ | 1123 | 1.2% |
| P | 1123 | 1.2% |
| Other values (6) | 6103 | 6.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 90010 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 37027 | |
| D | 24461 | |
| d | 11443 | 12.7% |
| N | 2246 | 2.5% |
| G | 2246 | 2.5% |
| e | 1992 | 2.2% |
| L | 1123 | 1.2% |
| I | 1123 | 1.2% |
| _ | 1123 | 1.2% |
| P | 1123 | 1.2% |
| Other values (6) | 6103 | 6.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 90010 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 37027 | |
| D | 24461 | |
| d | 11443 | 12.7% |
| N | 2246 | 2.5% |
| G | 2246 | 2.5% |
| e | 1992 | 2.2% |
| L | 1123 | 1.2% |
| I | 1123 | 1.2% |
| _ | 1123 | 1.2% |
| P | 1123 | 1.2% |
| Other values (6) | 6103 | 6.8% |
impression_share
Real number (ℝ)
| Distinct | 45199 |
|---|---|
| Distinct (%) | 15.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16.656556 |
| Minimum | 0 |
|---|---|
| Maximum | 100 |
| Zeros | 282 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 9.99 |
| median | 11.421975 |
| Q3 | 20.122939 |
| 95-th percentile | 41.807143 |
| Maximum | 100 |
| Range | 100 |
| Interquartile range (IQR) | 10.132939 |
Descriptive statistics
| Standard deviation | 12.186418 |
|---|---|
| Coefficient of variation (CV) | 0.73162892 |
| Kurtosis | 7.3435747 |
| Mean | 16.656556 |
| Median Absolute Deviation (MAD) | 3.2413049 |
| Skewness | 2.3309826 |
| Sum | 4829168.7 |
| Variance | 148.50879 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 9.99 | 43410 | 15.0% |
| 5 | 15687 | 5.4% |
| 9.99 | 3625 | 1.3% |
| 9.99 | 3013 | 1.0% |
| 100 | 300 | 0.1% |
| 0 | 282 | 0.1% |
| 11.04821634 | 135 | < 0.1% |
| 50 | 124 | < 0.1% |
| 5.415840824 | 110 | < 0.1% |
| 6.065072029 | 102 | < 0.1% |
| Other values (45189) | 223138 |
| Value | Count | Frequency (%) |
| 0 | 282 | 0.1% |
| 5 | 15687 | |
| 5.005319149 | 7 | < 0.1% |
| 5.006038647 | 9 | < 0.1% |
| 5.006067961 | 8 | < 0.1% |
| 5.006699561 | 9 | < 0.1% |
| 5.007146199 | 7 | < 0.1% |
| 5.007886435 | 4 | < 0.1% |
| 5.007976501 | 8 | < 0.1% |
| 5.008654391 | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| 100 | 300 | |
| 99.49367089 | 3 | < 0.1% |
| 97.61904762 | 2 | < 0.1% |
| 97.3 | 2 | < 0.1% |
| 97.06 | 2 | < 0.1% |
| 96.98275862 | 1 | < 0.1% |
| 96.77 | 2 | < 0.1% |
| 96.65178571 | 2 | < 0.1% |
| 96.32107023 | 2 | < 0.1% |
| 96.17391304 | 2 | < 0.1% |
conversions_calls
Real number (ℝ)
HIGH CORRELATION MISSING ZEROS
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 9855 |
| Missing (%) | 3.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.12792828 |
| Minimum | 0 |
|---|---|
| Maximum | 8 |
| Zeros | 258674 |
| Zeros (%) | 89.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 8 |
| Range | 8 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.52636239 |
|---|---|
| Coefficient of variation (CV) | 4.1145118 |
| Kurtosis | 41.506321 |
| Mean | 0.12792828 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.6326532 |
| Sum | 35829 |
| Variance | 0.27705737 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=9)
| Value | Count | Frequency (%) |
| 0 | 258674 | |
| 1 | 12334 | 4.3% |
| 2 | 5697 | 2.0% |
| 3 | 2197 | 0.8% |
| 4 | 680 | 0.2% |
| 5 | 296 | 0.1% |
| 6 | 81 | < 0.1% |
| 7 | 72 | < 0.1% |
| 8 | 40 | < 0.1% |
| (Missing) | 9855 | 3.4% |
| Value | Count | Frequency (%) |
| 0 | 258674 | |
| 1 | 12334 | 4.3% |
| 2 | 5697 | 2.0% |
| 3 | 2197 | 0.8% |
| 4 | 680 | 0.2% |
| 5 | 296 | 0.1% |
| 6 | 81 | < 0.1% |
| 7 | 72 | < 0.1% |
| 8 | 40 | < 0.1% |
| Value | Count | Frequency (%) |
| 8 | 40 | < 0.1% |
| 7 | 72 | < 0.1% |
| 6 | 81 | < 0.1% |
| 5 | 296 | 0.1% |
| 4 | 680 | 0.2% |
| 3 | 2197 | 0.8% |
| 2 | 5697 | 2.0% |
| 1 | 12334 | 4.3% |
| 0 | 258674 |
headline1_len
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 400 |
| Missing (%) | 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.7455842 |
| Minimum | 0 |
|---|---|
| Maximum | 7 |
| Zeros | 31252 |
| Zeros (%) | 10.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 2 |
| median | 3 |
| Q3 | 4 |
| 95-th percentile | 5 |
| Maximum | 7 |
| Range | 7 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.5711079 |
|---|---|
| Coefficient of variation (CV) | 0.57223083 |
| Kurtosis | -0.50210584 |
| Mean | 2.7455842 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.044273874 |
| Sum | 794918 |
| Variance | 2.46838 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=8)
| Value | Count | Frequency (%) |
| 3 | 71678 | |
| 2 | 70161 | |
| 4 | 48172 | |
| 5 | 31304 | |
| 0 | 31252 | |
| 1 | 26525 | 9.1% |
| 6 | 9209 | 3.2% |
| 7 | 1225 | 0.4% |
| (Missing) | 400 | 0.1% |
| Value | Count | Frequency (%) |
| 0 | 31252 | |
| 1 | 26525 | 9.1% |
| 2 | 70161 | |
| 3 | 71678 | |
| 4 | 48172 | |
| 5 | 31304 | |
| 6 | 9209 | 3.2% |
| 7 | 1225 | 0.4% |
| Value | Count | Frequency (%) |
| 7 | 1225 | 0.4% |
| 6 | 9209 | 3.2% |
| 5 | 31304 | |
| 4 | 48172 | |
| 3 | 71678 | |
| 2 | 70161 | |
| 1 | 26525 | 9.1% |
| 0 | 31252 |
headline2_len
Real number (ℝ)
ZEROS
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 400 |
| Missing (%) | 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.8798243 |
| Minimum | 0 |
|---|---|
| Maximum | 7 |
| Zeros | 31252 |
| Zeros (%) | 10.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 3 |
| Q3 | 4 |
| 95-th percentile | 5 |
| Maximum | 7 |
| Range | 7 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 1.670356 |
|---|---|
| Coefficient of variation (CV) | 0.58002013 |
| Kurtosis | -0.76204601 |
| Mean | 2.8798243 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | -0.12800913 |
| Sum | 833784 |
| Variance | 2.7900893 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=8)
| Value | Count | Frequency (%) |
| 3 | 69057 | |
| 4 | 68373 | |
| 1 | 42085 | |
| 5 | 33758 | |
| 2 | 32414 | |
| 0 | 31252 | |
| 6 | 10691 | 3.7% |
| 7 | 1896 | 0.7% |
| (Missing) | 400 | 0.1% |
| Value | Count | Frequency (%) |
| 0 | 31252 | |
| 1 | 42085 | |
| 2 | 32414 | |
| 3 | 69057 | |
| 4 | 68373 | |
| 5 | 33758 | |
| 6 | 10691 | 3.7% |
| 7 | 1896 | 0.7% |
| Value | Count | Frequency (%) |
| 7 | 1896 | 0.7% |
| 6 | 10691 | 3.7% |
| 5 | 33758 | |
| 4 | 68373 | |
| 3 | 69057 | |
| 2 | 32414 | |
| 1 | 42085 | |
| 0 | 31252 |
ad_description_len
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 21 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 400 |
| Missing (%) | 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10.706165 |
| Minimum | 0 |
|---|---|
| Maximum | 20 |
| Zeros | 31252 |
| Zeros (%) | 10.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 10 |
| median | 12 |
| Q3 | 14 |
| 95-th percentile | 16 |
| Maximum | 20 |
| Range | 20 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 4.5094501 |
|---|---|
| Coefficient of variation (CV) | 0.42120127 |
| Kurtosis | 0.8903601 |
| Mean | 10.706165 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | -1.289286 |
| Sum | 3099713 |
| Variance | 20.33514 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=21)
| Value | Count | Frequency (%) |
| 13 | 51850 | |
| 14 | 38077 | |
| 11 | 37260 | |
| 12 | 33490 | |
| 0 | 31252 | |
| 10 | 26916 | |
| 15 | 15303 | 5.3% |
| 16 | 12563 | 4.3% |
| 9 | 10799 | 3.7% |
| 7 | 9397 | 3.2% |
| Other values (11) | 22619 |
| Value | Count | Frequency (%) |
| 0 | 31252 | |
| 1 | 1 | < 0.1% |
| 2 | 723 | 0.2% |
| 3 | 1342 | 0.5% |
| 4 | 1571 | 0.5% |
| 5 | 3893 | 1.3% |
| 6 | 2504 | 0.9% |
| 7 | 9397 | 3.2% |
| 8 | 4843 | 1.7% |
| 9 | 10799 | 3.7% |
| Value | Count | Frequency (%) |
| 20 | 105 | < 0.1% |
| 19 | 303 | 0.1% |
| 18 | 637 | 0.2% |
| 17 | 6697 | 2.3% |
| 16 | 12563 | 4.3% |
| 15 | 15303 | 5.3% |
| 14 | 38077 | |
| 13 | 51850 | |
| 12 | 33490 | |
| 11 | 37260 |
| ad_description_len | ad_type | call_status | call_type | clicks | conversions | conversions_calls | cost | currency | display_location | duration | headline1_len | headline2_len | impression_share | impressions | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ad_description_len | 1.000 | 0.575 | 0.064 | 0.065 | 0.124 | 0.065 | 0.040 | 0.098 | 0.063 | 0.237 | 0.002 | 0.409 | 0.381 | -0.059 | 0.176 |
| ad_type | 0.575 | 1.000 | 0.059 | 0.048 | 0.155 | -0.005 | -0.038 | 0.215 | 0.222 | 0.303 | 0.047 | 0.669 | 0.467 | -0.056 | 0.256 |
| call_status | 0.064 | 0.059 | 1.000 | 0.004 | -0.018 | 0.064 | 0.327 | 0.003 | 0.000 | 0.088 | 0.762 | 0.009 | -0.013 | 0.030 | -0.031 |
| call_type | 0.065 | 0.048 | 0.004 | 1.000 | -0.061 | -0.174 | 0.009 | -0.061 | 0.004 | 0.460 | 0.052 | -0.057 | -0.031 | 0.108 | -0.065 |
| clicks | 0.124 | 0.155 | -0.018 | -0.061 | 1.000 | 0.187 | 0.091 | 0.898 | 0.008 | 1.000 | -0.021 | 0.026 | 0.313 | -0.019 | 0.847 |
| conversions | 0.065 | -0.005 | 0.064 | -0.174 | 0.187 | 1.000 | 0.384 | 0.182 | 0.008 | 0.194 | 0.073 | 0.039 | 0.079 | -0.037 | 0.156 |
| conversions_calls | 0.040 | -0.038 | 0.327 | 0.009 | 0.091 | 0.384 | 1.000 | 0.081 | 0.068 | 0.147 | 0.535 | 0.014 | -0.017 | 0.086 | 0.052 |
| cost | 0.098 | 0.215 | 0.003 | -0.061 | 0.898 | 0.182 | 0.081 | 1.000 | 0.007 | 0.021 | 0.003 | 0.070 | 0.316 | 0.034 | 0.783 |
| currency | 0.063 | 0.222 | 0.000 | 0.004 | 0.008 | 0.008 | 0.068 | 0.007 | 1.000 | 0.100 | -0.012 | -0.081 | 0.001 | 0.033 | -0.010 |
| display_location | 0.237 | 0.303 | 0.088 | 0.460 | 1.000 | 0.194 | 0.147 | 0.021 | 0.100 | 1.000 | -0.171 | -0.024 | 0.036 | -0.275 | 0.010 |
| duration | 0.002 | 0.047 | 0.762 | 0.052 | -0.021 | 0.073 | 0.535 | 0.003 | -0.012 | -0.171 | 1.000 | -0.022 | -0.010 | 0.136 | -0.034 |
| headline1_len | 0.409 | 0.669 | 0.009 | -0.057 | 0.026 | 0.039 | 0.014 | 0.070 | -0.081 | -0.024 | -0.022 | 1.000 | 0.332 | -0.098 | 0.104 |
| headline2_len | 0.381 | 0.467 | -0.013 | -0.031 | 0.313 | 0.079 | -0.017 | 0.316 | 0.001 | 0.036 | -0.010 | 0.332 | 1.000 | -0.003 | 0.392 |
| impression_share | -0.059 | -0.056 | 0.030 | 0.108 | -0.019 | -0.037 | 0.086 | 0.034 | 0.033 | -0.275 | 0.136 | -0.098 | -0.003 | 1.000 | -0.076 |
| impressions | 0.176 | 0.256 | -0.031 | -0.065 | 0.847 | 0.156 | 0.052 | 0.783 | -0.010 | 0.010 | -0.034 | 0.104 | 0.392 | -0.076 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
| impressions | clicks | cost | conversions | ad_type | currency | ID | date | call_type | call_status | start_time | duration | end_time | display_location | impression_share | conversions_calls | headline1_len | headline2_len | ad_description_len | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 142.0 | 15.0 | 3393.0 | 0.0 | EXPANDED_TEXT_AD | ZAR | ID_5da86e71bf5dee4cf5047046 | 2020-01-01 | NaN | NaN | NaN | NaN | NaN | NaN | 16.279669 | 0.0 | 2.0 | 5.0 | 11.0 |
| 1 | 89.0 | 8.0 | 1817.0 | 0.0 | EXPANDED_TEXT_AD | ZAR | ID_5da86e71bf5dee4cf5047046 | 2020-01-01 | NaN | NaN | NaN | NaN | NaN | NaN | 16.279669 | 0.0 | 2.0 | 2.0 | 13.0 |
| 2 | 59.0 | 8.0 | 1743.0 | 0.0 | EXPANDED_TEXT_AD | ZAR | ID_5da86e71bf5dee4cf5047046 | 2020-01-01 | NaN | NaN | NaN | NaN | NaN | NaN | 16.279669 | 0.0 | 2.0 | 2.0 | 10.0 |
| 3 | 78.0 | 4.0 | 917.0 | 0.0 | EXPANDED_TEXT_AD | ZAR | ID_5da86e71bf5dee4cf5047046 | 2020-01-01 | NaN | NaN | NaN | NaN | NaN | NaN | 16.279669 | 0.0 | 2.0 | 3.0 | 13.0 |
| 4 | 20.0 | 1.0 | 217.0 | 0.0 | EXPANDED_TEXT_AD | ZAR | ID_5da86e71bf5dee4cf5047046 | 2020-01-01 | NaN | NaN | NaN | NaN | NaN | NaN | 16.279669 | 0.0 | 2.0 | 2.0 | 13.0 |
| 5 | 5.0 | 0.0 | 0.0 | 0.0 | EXPANDED_TEXT_AD | ZAR | ID_5da86e71bf5dee4cf5047046 | 2020-01-01 | NaN | NaN | NaN | NaN | NaN | NaN | 16.279669 | 0.0 | 2.0 | 4.0 | 10.0 |
| 6 | 149.0 | 21.0 | 4091.0 | 0.0 | EXPANDED_TEXT_AD | ZAR | ID_5da86e71bf5dee4cf5047046 | 2020-01-02 | NaN | NaN | NaN | NaN | NaN | NaN | 16.227089 | 0.0 | 2.0 | 5.0 | 11.0 |
| 7 | 78.0 | 11.0 | 2199.0 | 0.0 | EXPANDED_TEXT_AD | ZAR | ID_5da86e71bf5dee4cf5047046 | 2020-01-02 | NaN | NaN | NaN | NaN | NaN | NaN | 16.227089 | 0.0 | 2.0 | 2.0 | 13.0 |
| 8 | 81.0 | 10.0 | 2024.0 | 0.0 | EXPANDED_TEXT_AD | ZAR | ID_5da86e71bf5dee4cf5047046 | 2020-01-02 | NaN | NaN | NaN | NaN | NaN | NaN | 16.227089 | 0.0 | 2.0 | 3.0 | 13.0 |
| 9 | 52.0 | 4.0 | 706.0 | 0.0 | EXPANDED_TEXT_AD | ZAR | ID_5da86e71bf5dee4cf5047046 | 2020-01-02 | NaN | NaN | NaN | NaN | NaN | NaN | 16.227089 | 0.0 | 2.0 | 2.0 | 10.0 |
| impressions | clicks | cost | conversions | ad_type | currency | ID | date | call_type | call_status | start_time | duration | end_time | display_location | impression_share | conversions_calls | headline1_len | headline2_len | ad_description_len | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 289916 | NaN | NaN | NaN | NaN | NaN | NaN | ID_6567476a4a967518c623d506 | 2024-02-02 | NaN | NaN | NaN | NaN | NaN | NaN | 10.072523 | 0.0 | NaN | NaN | NaN |
| 289917 | NaN | NaN | NaN | NaN | NaN | NaN | ID_6567476a4a967518c623d506 | 2024-02-03 | NaN | NaN | NaN | NaN | NaN | NaN | 10.614376 | 0.0 | NaN | NaN | NaN |
| 289918 | NaN | NaN | NaN | NaN | NaN | NaN | ID_656747739b5c72023947f7c7 | 2024-02-02 | NaN | NaN | NaN | NaN | NaN | NaN | 9.990000 | 0.0 | NaN | NaN | NaN |
| 289919 | NaN | NaN | NaN | NaN | NaN | NaN | ID_656747739b5c72023947f7c7 | 2024-02-03 | NaN | NaN | NaN | NaN | NaN | NaN | 9.990000 | 0.0 | NaN | NaN | NaN |
| 289920 | NaN | NaN | NaN | NaN | NaN | NaN | ID_656747739b5c72023947f7c7 | 2024-02-04 | NaN | NaN | NaN | NaN | NaN | NaN | 9.990000 | 0.0 | NaN | NaN | NaN |
| 289921 | NaN | NaN | NaN | NaN | NaN | NaN | ID_65687e2b40ea026fcc662a75 | 2024-02-03 | NaN | NaN | NaN | NaN | NaN | NaN | 12.035682 | 0.0 | NaN | NaN | NaN |
| 289922 | NaN | NaN | NaN | NaN | NaN | NaN | ID_65687e2b40ea026fcc662a75 | 2024-02-04 | NaN | NaN | NaN | NaN | NaN | NaN | 15.711023 | 0.0 | NaN | NaN | NaN |
| 289923 | NaN | NaN | NaN | NaN | NaN | NaN | ID_65a7bf329fa4627faf28390c | 2024-02-03 | NaN | NaN | NaN | NaN | NaN | NaN | 15.464425 | 0.0 | NaN | NaN | NaN |
| 289924 | NaN | NaN | NaN | NaN | NaN | NaN | ID_65b0f65c7fe62e56c5593d55 | 2024-02-03 | NaN | NaN | NaN | NaN | NaN | NaN | 10.016481 | 0.0 | NaN | NaN | NaN |
| 289925 | NaN | NaN | NaN | NaN | NaN | NaN | ID_65b0f65c7fe62e56c5593d55 | 2024-02-04 | NaN | NaN | NaN | NaN | NaN | NaN | 9.990000 | 0.0 | NaN | NaN | NaN |
Most frequently occurring
| impressions | clicks | cost | conversions | ad_type | currency | ID | date | call_type | call_status | start_time | duration | end_time | display_location | impression_share | conversions_calls | headline1_len | headline2_len | ad_description_len | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1.0 | 0.0 | 0.0 | 0.0 | EXPANDED_DYNAMIC_SEARCH_AD | ZAR | ID_5da86e71bf5dee4cf5047046 | 2020-04-15 | NaN | NaN | NaN | NaN | NaN | NaN | 24.899634 | 0.0 | 1.0 | 1.0 | 10.0 | 2 |
| 1 | 1.0 | 0.0 | 0.0 | 0.0 | EXPANDED_DYNAMIC_SEARCH_AD | ZAR | ID_5da86e71bf5dee4cf5047046 | 2020-05-01 | NaN | NaN | NaN | NaN | NaN | NaN | 32.077031 | 0.0 | 1.0 | 1.0 | 10.0 | 2 |
| 2 | 1.0 | 0.0 | 0.0 | 0.0 | EXPANDED_DYNAMIC_SEARCH_AD | ZAR | ID_5da86e71bf5dee4cf5047046 | 2020-06-19 | NaN | NaN | NaN | NaN | NaN | NaN | 31.840334 | 0.0 | 1.0 | 1.0 | 10.0 | 2 |
| 3 | 1.0 | 0.0 | 0.0 | 0.0 | EXPANDED_DYNAMIC_SEARCH_AD | ZAR | ID_5da86e71bf5dee4cf5047046 | 2020-06-23 | NaN | NaN | NaN | NaN | NaN | NaN | 28.208670 | 0.0 | 1.0 | 1.0 | 10.0 | 2 |
| 4 | 1.0 | 0.0 | 0.0 | 0.0 | EXPANDED_DYNAMIC_SEARCH_AD | ZAR | ID_5da86e71bf5dee4cf5047046 | 2020-06-27 | NaN | NaN | NaN | NaN | NaN | NaN | 19.414253 | 0.0 | 1.0 | 1.0 | 10.0 | 2 |
| 5 | 1.0 | 0.0 | 0.0 | 0.0 | EXPANDED_DYNAMIC_SEARCH_AD | ZAR | ID_5da86e71bf5dee4cf5047046 | 2020-07-04 | NaN | NaN | NaN | NaN | NaN | NaN | 21.264645 | 0.0 | 1.0 | 1.0 | 10.0 | 2 |
| 6 | 1.0 | 0.0 | 0.0 | 0.0 | EXPANDED_DYNAMIC_SEARCH_AD | ZAR | ID_5da86e71bf5dee4cf5047046 | 2020-07-07 | NaN | NaN | NaN | NaN | NaN | NaN | 21.885952 | 1.0 | 1.0 | 1.0 | 10.0 | 2 |
| 7 | 1.0 | 0.0 | 0.0 | 0.0 | EXPANDED_DYNAMIC_SEARCH_AD | ZAR | ID_5da86e71bf5dee4cf5047046 | 2020-07-07 | NaN | NaN | NaN | NaN | NaN | NaN | 21.885952 | 1.0 | 1.0 | 1.0 | 13.0 | 2 |
| 8 | 1.0 | 0.0 | 0.0 | 0.0 | EXPANDED_DYNAMIC_SEARCH_AD | ZAR | ID_5da86e71bf5dee4cf5047046 | 2020-07-31 | NaN | NaN | NaN | NaN | NaN | NaN | 26.068539 | 0.0 | 1.0 | 1.0 | 10.0 | 2 |
| 9 | 1.0 | 0.0 | 0.0 | 0.0 | EXPANDED_DYNAMIC_SEARCH_AD | ZAR | ID_5da86e71bf5dee4cf5047046 | 2020-08-14 | NaN | NaN | NaN | NaN | NaN | NaN | 22.084245 | 0.0 | 1.0 | 1.0 | 10.0 | 2 |